﻿IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME
= 'SkillsCourseStudentAnswer' AND COLUMN_NAME = 'UpdatedBy')
BEGIN
     ALTER TABLE [SkillsCourseStudentAnswer] ADD UpdatedBy VARCHAR(50) NULL
END
GO

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME
= 'SkillsStudentAnswer' AND COLUMN_NAME = 'UpdatedBy')
BEGIN
     ALTER TABLE [SkillsStudentAnswer] ADD UpdatedBy VARCHAR(50) NULL
END
GO

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME
= 'SkillsCourseStudentAnswer' AND COLUMN_NAME = 'UpdatedWhen')
BEGIN
     ALTER TABLE [SkillsCourseStudentAnswer] ADD UpdatedWhen DATETIME NULL
END
GO

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME
= 'SkillsStudentAnswer' AND COLUMN_NAME = 'UpdatedWhen')
BEGIN
     ALTER TABLE [SkillsStudentAnswer] ADD UpdatedWhen DATETIME NULL
END
GO

DECLARE @SQLStr VARCHAR(1000)
SELECT @SQLStr ='UPDATE  SkillsCourseStudentAnswer SET UpdatedBy =
''Admin'' WHERE UpdatedBy IS NULL'
EXEC (@SQLStr)
SELECT @SQLStr = 'UPDATE  SkillsCourseStudentAnswer SET UpdatedWhen =
GETDATE() WHERE UpdatedWhen IS NULL'
EXEC (@SQLStr)
SELECT @SQLStr = ' UPDATE  SkillsStudentAnswer SET UpdatedBy = ''Admin''
WHERE UpdatedBy IS NULL'
EXEC (@SQLStr)
SELECT @SQLStr = 'UPDATE  SkillsStudentAnswer SET UpdatedWhen =
GETDATE() WHERE UpdatedWhen IS NULL'
EXEC (@SQLStr)

SELECT @SQLStr = 'ALTER TABLE SkillsCourseStudentAnswer ALTER COLUMN
UpdatedBy VARCHAR(50) NOT NULL'
EXEC (@SQLStr)
SELECT @SQLStr = 'ALTER TABLE SkillsCourseStudentAnswer ALTER COLUMN
UpdatedWhen DATETIME NOT NULL'
EXEC (@SQLStr)
SELECT @SQLStr = 'ALTER TABLE SkillsStudentAnswer ALTER COLUMN UpdatedBy
VARCHAR(50) NOT NULL'
EXEC (@SQLStr)
SELECT @SQLStr = 'ALTER TABLE SkillsStudentAnswer ALTER COLUMN
UpdatedWhen DATETIME NOT NULL'
EXEC (@SQLStr)

GO